SQLSAM: SQL for statistical analysis and modeling

Abstrait Statistical modeling and analysis is extensively used in businesses for various purposes including graphic visualization of data, measurement of central tendencies and other statistics, and inferences on populations based on samples. Data are the fundamental component of each of these activities. In this paper an extension of the standard database language SQL for statistical modeling and analysis is presented. Models covered include descriptive analytic and graphic measures, discrete probability distributions, continuous probability distributions, inferential statistics, and regression analysis. Through the use of SQLSAM, seamless integration of existing data in organizations’ databases and their statistical analysis can be achieved.